using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class DMS028ManagerBase
    {
        public DMS028ManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity Insert(DMS028Entity obj)
        { 
            return (DMS028Entity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity Update(DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.Update(obj);             
        }
 
 
        public DMS028Entity Delete(DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.Delete(obj);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByORDER_NO (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByORDER_NO (string ORDER_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ORDER_NO = ORDER_NO;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByPART_NO (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"PART_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PART_NO 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByPART_NO (string PART_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PART_NO = PART_NO;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"PART_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByLINE_NO (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"LINE_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LINE_NO 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByLINE_NO (string LINE_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LINE_NO = LINE_NO;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"LINE_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByWH_CODE (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien WH_CODE 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByWH_CODE (string WH_CODE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.WH_CODE = WH_CODE;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteBySTATUS (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"STATUS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien STATUS 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteBySTATUS (string STATUS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.STATUS = STATUS;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"STATUS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByBO_FLAG (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"BO_FLAG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BO_FLAG 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByBO_FLAG (string BO_FLAG )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_FLAG = BO_FLAG;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"BO_FLAG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByQTY (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QTY 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByQTY (double QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.QTY = QTY;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByPRICE (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"PRICE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien PRICE 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByPRICE (double PRICE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PRICE = PRICE;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"PRICE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByALL_QTY (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"ALL_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ALL_QTY 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByALL_QTY (double ALL_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ALL_QTY = ALL_QTY;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"ALL_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByBO_QTY (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"BO_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien BO_QTY 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByBO_QTY (double BO_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_QTY = BO_QTY;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"BO_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByDLV_QTY (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"DLV_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DLV_QTY 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByDLV_QTY (double DLV_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DLV_QTY = DLV_QTY;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"DLV_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCANCEL_QTY (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"CANCEL_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CANCEL_QTY 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCANCEL_QTY (double CANCEL_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"CANCEL_QTY");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByDISCOUNT_RATE (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"DISCOUNT_RATE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DISCOUNT_RATE 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByDISCOUNT_RATE (double DISCOUNT_RATE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"DISCOUNT_RATE");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByDISCOUNT_AMNT (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"DISCOUNT_AMNT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DISCOUNT_AMNT 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByDISCOUNT_AMNT (double DISCOUNT_AMNT )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"DISCOUNT_AMNT");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByVAT_ID (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"VAT_ID");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien VAT_ID 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByVAT_ID (string VAT_ID )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.VAT_ID = VAT_ID;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"VAT_ID");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByACTFLG (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ACTFLG 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByACTFLG (string ACTFLG )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ACTFLG = ACTFLG;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCTDUSR (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDUSR 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCTDUSR (string CTDUSR )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDUSR = CTDUSR;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCTDWKS (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDWKS 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCTDWKS (string CTDWKS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDWKS = CTDWKS;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCTDPGM (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDPGM 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCTDPGM (string CTDPGM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDPGM = CTDPGM;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCTDDTM (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CTDDTM 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByCTDDTM (DateTime CTDDTM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDDTM = CTDDTM;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByMDFUSR (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFUSR 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByMDFUSR (string MDFUSR )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFUSR = MDFUSR;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByMDFWKS (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFWKS 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByMDFWKS (string MDFWKS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFWKS = MDFWKS;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByMDFPGM (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MDFPGM 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByMDFPGM (string MDFPGM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFPGM = MDFPGM;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByLSTMDF (DMS028Entity obj)
        { 
            return (DMS028Entity)Adapter.DeleteByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien LSTMDF 
        /// </summary>
        /// <returns>DMS028Entity</returns>
        public DMS028Entity DeleteByLSTMDF (DateTime LSTMDF )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LSTMDF = LSTMDF;  
            return (DMS028Entity)Adapter.DeleteByField(obj,"LSTMDF");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public DMS028Entity Select(DMS028Entity obj)
        { 
            return (DMS028Entity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(DMS028Entity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(DMS028Entity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new DMS028Entity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new DMS028Entity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<DMS028Entity> SelectAllLST()
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new DMS028Entity()),new DMS028Entity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<DMS028Entity> SelectAllLST(SelectOptions option)
        { 
            return (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new DMS028Entity(),option),new DMS028Entity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ORDER_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByORDER_NOLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByORDER_NOLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ORDER_NO",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (string ORDER_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ORDER_NO = ORDER_NO;  
            return Adapter.SelectByField(obj,"ORDER_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByORDER_NO (string ORDER_NO, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ORDER_NO = ORDER_NO;  
            return Adapter.SelectByField(obj,"ORDER_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByORDER_NOLST (string ORDER_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ORDER_NO = ORDER_NO;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ORDER_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByORDER_NOLST (string ORDER_NO, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ORDER_NO = ORDER_NO;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ORDER_NO",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"PART_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"PART_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByPART_NOLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByPART_NOLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"PART_NO",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (string PART_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PART_NO = PART_NO;  
            return Adapter.SelectByField(obj,"PART_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPART_NO (string PART_NO, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PART_NO = PART_NO;  
            return Adapter.SelectByField(obj,"PART_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByPART_NOLST (string PART_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PART_NO = PART_NO;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PART_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByPART_NOLST (string PART_NO, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PART_NO = PART_NO;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PART_NO",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_NO (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"LINE_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_NO (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"LINE_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByLINE_NOLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_NO"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByLINE_NOLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"LINE_NO",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_NO (string LINE_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LINE_NO = LINE_NO;  
            return Adapter.SelectByField(obj,"LINE_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLINE_NO (string LINE_NO, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LINE_NO = LINE_NO;  
            return Adapter.SelectByField(obj,"LINE_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByLINE_NOLST (string LINE_NO )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LINE_NO = LINE_NO;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_NO"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LINE_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByLINE_NOLST (string LINE_NO, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LINE_NO = LINE_NO;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LINE_NO",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"WH_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByWH_CODELST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByWH_CODELST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"WH_CODE",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (string WH_CODE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.WH_CODE = WH_CODE;  
            return Adapter.SelectByField(obj,"WH_CODE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWH_CODE (string WH_CODE, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.WH_CODE = WH_CODE;  
            return Adapter.SelectByField(obj,"WH_CODE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByWH_CODELST (string WH_CODE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.WH_CODE = WH_CODE;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien WH_CODE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByWH_CODELST (string WH_CODE, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.WH_CODE = WH_CODE;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"WH_CODE",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"STATUS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"STATUS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectBySTATUSLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectBySTATUSLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"STATUS",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (string STATUS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.STATUS = STATUS;  
            return Adapter.SelectByField(obj,"STATUS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySTATUS (string STATUS, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.STATUS = STATUS;  
            return Adapter.SelectByField(obj,"STATUS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectBySTATUSLST (string STATUS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.STATUS = STATUS;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien STATUS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectBySTATUSLST (string STATUS, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.STATUS = STATUS;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"STATUS",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_FLAG (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"BO_FLAG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_FLAG (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"BO_FLAG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByBO_FLAGLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_FLAG"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByBO_FLAGLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"BO_FLAG",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_FLAG (string BO_FLAG )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_FLAG = BO_FLAG;  
            return Adapter.SelectByField(obj,"BO_FLAG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_FLAG (string BO_FLAG, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_FLAG = BO_FLAG;  
            return Adapter.SelectByField(obj,"BO_FLAG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByBO_FLAGLST (string BO_FLAG )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_FLAG = BO_FLAG;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_FLAG"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_FLAG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByBO_FLAGLST (string BO_FLAG, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_FLAG = BO_FLAG;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_FLAG",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByQTYLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByQTYLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (double QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.QTY = QTY;  
            return Adapter.SelectByField(obj,"QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQTY (double QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.QTY = QTY;  
            return Adapter.SelectByField(obj,"QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByQTYLST (double QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.QTY = QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByQTYLST (double QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.QTY = QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"PRICE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"PRICE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByPRICELST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByPRICELST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"PRICE",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE (double PRICE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PRICE = PRICE;  
            return Adapter.SelectByField(obj,"PRICE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPRICE (double PRICE, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PRICE = PRICE;  
            return Adapter.SelectByField(obj,"PRICE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByPRICELST (double PRICE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PRICE = PRICE;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien PRICE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByPRICELST (double PRICE, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.PRICE = PRICE;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"PRICE",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByALL_QTY (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"ALL_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByALL_QTY (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ALL_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByALL_QTYLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ALL_QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByALL_QTYLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ALL_QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByALL_QTY (double ALL_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ALL_QTY = ALL_QTY;  
            return Adapter.SelectByField(obj,"ALL_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByALL_QTY (double ALL_QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ALL_QTY = ALL_QTY;  
            return Adapter.SelectByField(obj,"ALL_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByALL_QTYLST (double ALL_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ALL_QTY = ALL_QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ALL_QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ALL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByALL_QTYLST (double ALL_QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ALL_QTY = ALL_QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ALL_QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_QTY (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"BO_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_QTY (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"BO_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByBO_QTYLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByBO_QTYLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"BO_QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_QTY (double BO_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_QTY = BO_QTY;  
            return Adapter.SelectByField(obj,"BO_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBO_QTY (double BO_QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_QTY = BO_QTY;  
            return Adapter.SelectByField(obj,"BO_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByBO_QTYLST (double BO_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_QTY = BO_QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien BO_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByBO_QTYLST (double BO_QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.BO_QTY = BO_QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"BO_QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDLV_QTY (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"DLV_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDLV_QTY (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DLV_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByDLV_QTYLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DLV_QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByDLV_QTYLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DLV_QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDLV_QTY (double DLV_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DLV_QTY = DLV_QTY;  
            return Adapter.SelectByField(obj,"DLV_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDLV_QTY (double DLV_QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DLV_QTY = DLV_QTY;  
            return Adapter.SelectByField(obj,"DLV_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByDLV_QTYLST (double DLV_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DLV_QTY = DLV_QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DLV_QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DLV_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByDLV_QTYLST (double DLV_QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DLV_QTY = DLV_QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DLV_QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCANCEL_QTY (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"CANCEL_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCANCEL_QTY (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CANCEL_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCANCEL_QTYLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CANCEL_QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCANCEL_QTYLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CANCEL_QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCANCEL_QTY (double CANCEL_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return Adapter.SelectByField(obj,"CANCEL_QTY");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCANCEL_QTY (double CANCEL_QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return Adapter.SelectByField(obj,"CANCEL_QTY",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCANCEL_QTYLST (double CANCEL_QTY )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CANCEL_QTY"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CANCEL_QTY duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCANCEL_QTYLST (double CANCEL_QTY, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CANCEL_QTY = CANCEL_QTY;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CANCEL_QTY",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_RATE (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"DISCOUNT_RATE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_RATE (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DISCOUNT_RATE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByDISCOUNT_RATELST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_RATE"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByDISCOUNT_RATELST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DISCOUNT_RATE",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_RATE (double DISCOUNT_RATE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return Adapter.SelectByField(obj,"DISCOUNT_RATE");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_RATE (double DISCOUNT_RATE, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return Adapter.SelectByField(obj,"DISCOUNT_RATE",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByDISCOUNT_RATELST (double DISCOUNT_RATE )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_RATE"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_RATE duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByDISCOUNT_RATELST (double DISCOUNT_RATE, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_RATE = DISCOUNT_RATE;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_RATE",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_AMNT (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"DISCOUNT_AMNT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_AMNT (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DISCOUNT_AMNT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByDISCOUNT_AMNTLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_AMNT"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByDISCOUNT_AMNTLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DISCOUNT_AMNT",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_AMNT (double DISCOUNT_AMNT )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return Adapter.SelectByField(obj,"DISCOUNT_AMNT");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDISCOUNT_AMNT (double DISCOUNT_AMNT, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return Adapter.SelectByField(obj,"DISCOUNT_AMNT",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByDISCOUNT_AMNTLST (double DISCOUNT_AMNT )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_AMNT"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DISCOUNT_AMNT duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByDISCOUNT_AMNTLST (double DISCOUNT_AMNT, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.DISCOUNT_AMNT = DISCOUNT_AMNT;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DISCOUNT_AMNT",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_ID (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"VAT_ID");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_ID (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"VAT_ID",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByVAT_IDLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_ID"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByVAT_IDLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"VAT_ID",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_ID (string VAT_ID )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.VAT_ID = VAT_ID;  
            return Adapter.SelectByField(obj,"VAT_ID");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByVAT_ID (string VAT_ID, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.VAT_ID = VAT_ID;  
            return Adapter.SelectByField(obj,"VAT_ID",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByVAT_IDLST (string VAT_ID )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.VAT_ID = VAT_ID;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_ID"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien VAT_ID duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByVAT_IDLST (string VAT_ID, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.VAT_ID = VAT_ID;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"VAT_ID",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ACTFLG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByACTFLGLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByACTFLGLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ACTFLG",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (string ACTFLG )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ACTFLG = ACTFLG;  
            return Adapter.SelectByField(obj,"ACTFLG");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByACTFLG (string ACTFLG, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ACTFLG = ACTFLG;  
            return Adapter.SelectByField(obj,"ACTFLG",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByACTFLGLST (string ACTFLG )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ACTFLG = ACTFLG;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ACTFLG duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByACTFLGLST (string ACTFLG, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.ACTFLG = ACTFLG;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ACTFLG",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCTDUSRLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCTDUSRLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDUSR",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (string CTDUSR )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDUSR = CTDUSR;  
            return Adapter.SelectByField(obj,"CTDUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDUSR (string CTDUSR, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDUSR = CTDUSR;  
            return Adapter.SelectByField(obj,"CTDUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCTDUSRLST (string CTDUSR )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDUSR = CTDUSR;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCTDUSRLST (string CTDUSR, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDUSR = CTDUSR;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDUSR",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCTDWKSLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCTDWKSLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDWKS",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (string CTDWKS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDWKS = CTDWKS;  
            return Adapter.SelectByField(obj,"CTDWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDWKS (string CTDWKS, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDWKS = CTDWKS;  
            return Adapter.SelectByField(obj,"CTDWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCTDWKSLST (string CTDWKS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDWKS = CTDWKS;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCTDWKSLST (string CTDWKS, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDWKS = CTDWKS;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDWKS",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCTDPGMLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCTDPGMLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDPGM",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (string CTDPGM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDPGM = CTDPGM;  
            return Adapter.SelectByField(obj,"CTDPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDPGM (string CTDPGM, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDPGM = CTDPGM;  
            return Adapter.SelectByField(obj,"CTDPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCTDPGMLST (string CTDPGM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDPGM = CTDPGM;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCTDPGMLST (string CTDPGM, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDPGM = CTDPGM;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDPGM",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CTDDTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCTDDTMLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByCTDDTMLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CTDDTM",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DateTime CTDDTM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDDTM = CTDDTM;  
            return Adapter.SelectByField(obj,"CTDDTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCTDDTM (DateTime CTDDTM, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDDTM = CTDDTM;  
            return Adapter.SelectByField(obj,"CTDDTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCTDDTMLST (DateTime CTDDTM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDDTM = CTDDTM;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CTDDTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByCTDDTMLST (DateTime CTDDTM, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.CTDDTM = CTDDTM;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CTDDTM",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByMDFUSRLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByMDFUSRLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFUSR",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (string MDFUSR )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFUSR = MDFUSR;  
            return Adapter.SelectByField(obj,"MDFUSR");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFUSR (string MDFUSR, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFUSR = MDFUSR;  
            return Adapter.SelectByField(obj,"MDFUSR",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByMDFUSRLST (string MDFUSR )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFUSR = MDFUSR;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFUSR duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByMDFUSRLST (string MDFUSR, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFUSR = MDFUSR;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFUSR",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByMDFWKSLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByMDFWKSLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFWKS",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (string MDFWKS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFWKS = MDFWKS;  
            return Adapter.SelectByField(obj,"MDFWKS");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFWKS (string MDFWKS, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFWKS = MDFWKS;  
            return Adapter.SelectByField(obj,"MDFWKS",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByMDFWKSLST (string MDFWKS )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFWKS = MDFWKS;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFWKS duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByMDFWKSLST (string MDFWKS, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFWKS = MDFWKS;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFWKS",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MDFPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByMDFPGMLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByMDFPGMLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MDFPGM",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (string MDFPGM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFPGM = MDFPGM;  
            return Adapter.SelectByField(obj,"MDFPGM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMDFPGM (string MDFPGM, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFPGM = MDFPGM;  
            return Adapter.SelectByField(obj,"MDFPGM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByMDFPGMLST (string MDFPGM )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFPGM = MDFPGM;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MDFPGM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByMDFPGMLST (string MDFPGM, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.MDFPGM = MDFPGM;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MDFPGM",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DMS028Entity obj)
        { 
            return Adapter.SelectByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DMS028Entity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"LSTMDF",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByLSTMDFLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectByLSTMDFLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"LSTMDF",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DateTime LSTMDF )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LSTMDF = LSTMDF;  
            return Adapter.SelectByField(obj,"LSTMDF");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByLSTMDF (DateTime LSTMDF, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LSTMDF = LSTMDF;  
            return Adapter.SelectByField(obj,"LSTMDF",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByLSTMDFLST (DateTime LSTMDF )
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LSTMDF = LSTMDF;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF"),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien LSTMDF duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<DMS028Entity> SelectByLSTMDFLST (DateTime LSTMDF, SelectOptions option)
        { 
            DMS028Entity obj = new DMS028Entity();
            obj.LSTMDF = LSTMDF;  
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"LSTMDF",option),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectWithConditionLST (DMS028Entity obj)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new DMS028Entity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<DMS028Entity></returns>
        public List<DMS028Entity> SelectWithConditionLST (DMS028Entity obj,SelectOptions option)
        { 
            return  (List<DMS028Entity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new DMS028Entity());
        }

}
}
